SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='T'
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Martin Brook Townhouse Grants Ownership Of The Building To The One Common Wall With The Neighbor. Gorgeous Hardwood Floors On 1st Level. Updated Kitchen/Dining Room W/Ample Cupboard Space, Granite Counter Tops, Spacious Center Island/Breakfast Bar. Pantry. Office/Bonus Room Faces The Privacy Of The Backyard. Living Room With Inviting Wood Burning Fireplace. Half Bath. The Second Floor Offers 3 Bedrooms, Each Of Varied Sizes. Full Bath. Tile Floor in Basement Family Room Covered With Easy To Remove Carpet. Room Off Family Room. Utility Room. Laundry Room Closet. Bulkhead With New Stairs. One Car, Attached Garage Allows Easy Access To The Kitchen Area. This Home Has Been Well Cared For. Immediately Ready For The New Owner. Martin Brook Offers On Site Mail Delivery. Easy Access To Upper Valley Employment, Recreation & Shopping. Don't Miss This One! Make This Charming Home Your Home!
Description:Welcome to your new home! This charming 2-bedroom/2 1/2 bath condo is within walking distance to downtown Hanover, Dartmouth College, and DHMC, offering the perfect blend of comfort and convenience. The cozy living room features hardwood floors and a brick fireplace, creating a warm and inviting atmosphere. It's connected to an open-concept kitchen and dining area, ideal for family gatherings. Upstairs, you'll find two bedrooms sharing a full bathroom. The master bedroom includes a stairway up to a spacious loft with large skylights, perfect for an office or cozy reading nook. The large finished basement has tile floors, a 3/4 bath, laundry with new washer/dryer, and a pellet stove that heats the entire unit in winter. Outside, there is a private rear deck, a shed, and a large lockable storage unit for extra belongings. Parking includes a carport and additional space. Schedule a viewing today to experience all this condo has to offer!
Description:NEW PRICE ......Fall in Love with History and Location™ Discover the best of village living in this Lyme Green Gem! This Circa 1816, desirably located condominium residence will offer you a unique blend of relaxation, tranquility and historical charm. The distinctive and charming first floor end unit boasts a second floor primary bedroom suite as well as a spacious first floor bedroom. Enhanced by stunning 1825 wide pine floors, original beams and custom built-ins throughout, this unit exuding warmth and and comfort. A delightful updated kitchen with sparkling new appliances and a 4 season sunporch overlooking a spacious backyard complete the package! Ideally located across from the Village Green, you'll find yourself just steps away from the country store, post office, banks , hardware store...and just around the corner from the Lyme School and town library. Delight in dining in the popular restaurants just steps away! ....And enjoy endless recreational activities in the hiking trails, ponds, river and the Dartmouth Skiway! Whether you are looking for your next home or a tranquil get away, this is your opportunity to experience the vibrant and welcoming community of Lyme. The perfect escape to simpler times, offering a bird's eye view of the charming 19th century village center. Fall in Love with History and Location™
Description:Light filled, well appointed 2 bedroom condo with open floor plan, built in cabinetry flanking propane firepalce, beadboard wainscoating, wide pine flooring and ample closet space. Gararge space with loft. Basement locked storage area. Small gardening plot for vegetables or perenials. Shared herb garden just outside the door. Owner rides his bike to work in Hanover, 30 mins!
Description:Experience sustainable living in this beautifully designed 2-bedroom, 2-bath LEED-certified, single level condo, perfectly situated close to everything you need. Enjoy modern finishes, energy-efficient features, and a smart layout that combines comfort with eco-conscious living. One of the few units to enjoy stunning westerly views of the mountains. Amenities include covered parking with a locked storage unit and one additional parking space. Conveniently located with access to nature and walking trails. Walk to Dartmouth Heath and short distance to downtown Hanover. Leased through May 31.